erd diagram.mwb

db sql.sql

• User

  • user_id (int, ai, pk, nn)
  • user_nickname (varchar(10), nn)
  • user_email (varchar(50), nn, uq)
  • user_password (varchar(150), nn)
  • user_salt (varchar(20), nn)
  • user_address (varchar(200))
  • user_area_code (varchar(10))
  • user_image_url (varchar(255), nn)
  • user_auth_level (int, nn, default(1))
    • 1 : 이메일 인증, 2 : 휴대폰 인증, 3 : 계좌 인증

• Deal(거래기록)

  • deal_id(int, ai, pk, nn)
  • deal_start_date (date, nn)
  • deal_end_date (date, nn)
  • deal_total_price (int, nn)
  • deal_status (varchar(10), nn) // 거래예약, 대여중(거래완료), 반납완료
  • buyer_id (int, fk, nn) // (== User.user_id)
  • seller_id (int, fk, nn) // (== User.user_id)
  • item_id (int, fk, nn) // (== Item.item_id)

• Item

  • item_id (int, ai, pk, nn)
  • item_name (varchar(20), nn)
  • item_content (varchar(1000), nn)
  • item_price (int, nn)
  • item_category (varchar(10), nn)
  • item_address (varchar(200), nn)
  • item_area_code (int, nn)
  • item_created_time (datetime, nn, default(현재시간))
  • item_modified_time (datetime, nn, default(현재시간))
  • item_is_active (varchar(1), nn, default(Y)) // Y : 활성화, N : 비활성화
  • seller_id (int, fk, nn)

• Image

  • image_id (int, ai, pk)
  • image_url (varchar(255), nn)
  • item_id (int, fk, nn)

• Bookmark

  • item_id (int, pk, nn)
  • user_id (int, pk, nn)

• Notice

  • notice_id (int, ai, pk, nn)
  • notice_title (varchar(100), nn)
  • notice_content (varchar(100), nn)
  • notice_time (datetime, nn)
  • notice_is_read(varchar(1), nn, default(N)) // Y : 읽음, N : 읽지않음
  • item_id (int, fk)
  • user_id (int, fk, nn) // 알림을 받는 사람 id

• chat

[email protected]

[email protected]