switch-switch

Tables (11)

Alarm

  • alarm_idx — varchar2(5char) — Primary key
  • sender_idx — varchar2(5char)
  • receiver_idx — varchar2(5char)
  • alarm_type — '교환요청', '요청수락', '채팅요청', '채팅요청거절', '채팅요청수락', '교환확정', '교환취소', '평점요청'

Card

  • card_idx — varchar2(5char) — Primary key
  • cardlist_idx — varchar2(5char)
  • category — varchar2
  • imglist_idx — varchar2(5char)
  • name — varchar2
  • condition — '1','2','3','4','5'
  • delivery_charge — 'Y','N'
  • exchange_type — '직거래','배송','협의 후 결정'
  • reg_date — date
  • isFree — 'Y','N' — NOT NULL
  • exchange_status — 'NO','진행중','EXCHANGED'

Cardlist

  • cardlist_idx — varchar2(5char)
  • user_id — varchar2

Chatting

  • chatting_idx — varchar2(5char)
  • attendee1 — varchar2
  • attendee2 — varchar2
  • recent_date — date
  • message_history — file

ChattingList

  • chattinglist_idx — varchar2(5char)
  • user_id — varchar2
  • chatting_idx — varchar2(5char)

ExchangeCardList

  • ex_cardlist_idx — varchar2(5char)
  • card_idx1 — varchar2(5char)
  • card_idx2 — varchar2(5char)
  • card_idx3 — varchar2(5char)
  • card_idx4 — varchar2(5char)

ExchangeHistory

  • eh_idx — varchar2(5char)
  • ex_cardlist_idx — varchar2(5char)
  • offer_cardlist_idx — varchar2(5char)
  • exchange_date — date
  • exchange_type — '직거래','배송','협의 후 결정'

Imglist

  • imglist_idx — varchar2(5char)
  • img1
  • img2
  • img3
  • img4

Member (Member1)

  • user_id — varchar2
  • password — varchar2
  • isLeave — '0','1'
  • region — varchar2

Rating

  • rating_idx — varchar2(5char) — Primary key
  • eh_idx — varchar2(5char)
  • user_id — varchar2
  • rating — '1','2','3','4','5'

WishList

  • wishlist_idx — varchar2(5char)
  • user_id — varchar2
  • card_idx — varchar2(5char)