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)