B104
Tables (10)
ChatMessage (채팅메세지)
- message_pk (메세지pk) — bigInt — Primary key — NOT NULL
- message_body (메세지내용) — varchar(255)
- message_time (메세지보낸시간) — timestamp
- chat_pk (채팅pk) — bigint — Foreign key → ChatRoom.chat_pk — NOT NULL
- member_pk (멤버PK) — bigInt — Foreign key → Member.member_pk — NOT NULL
ChatParticipant (채팅참여자)
- partici_pk (참여자pk) — bigInt — Primary key — NOT NULL
- member_pk (멤버PK) — bigInt — Foreign key → Member.member_pk — NOT NULL
- chat_pk (채팅pk) — bigint — Foreign key → ChatRoom.chat_pk — NOT NULL
- partici_join (입장시간) — timestamp
- partici_exit (퇴장시간) — timestamp
ChatRoom (채팅)
- chat_pk (채팅pk) — bigint — Primary key — NOT NULL
- chat_session (채팅세션) — varchar(15)
- chat_create (채팅방 생성시간) — timestamp
- chat_end (채팅방 소멸시간) — timestamp
- auction_pk (경매pk) — bigint — Foreign key → auction.auction_pk — NOT NULL
Member (유저)
- member_pk (멤버PK) — bigInt — Primary key — NOT NULL
- member_id (멤버아이디) — varchar(16)
- member_pw (멤버비밀번호) — varchar(255)
- member_email (멤버이메일) — varchar(40)
- member_address (멤버주소) — varchar(50)
- member_role (멤버역할) — varchar(5)
- member_nickname (멤버닉네임) — varchar(25)
- member_banned (멤버이용가능여부) — tinyint
- member_refresh (멤버리프레쉬) — varchar(255)
- member_fcm (멤버 FCM) — varchar(255)
- member_created_at (멤버 가입일자) — datetime
- member_update_at (멤버 수정일자) — datetime
Member_Follow (팔로우 가게)
- follow_pk (팔로우pk) — bigint — Primary key — NOT NULL
- shop_pk (팔로우가게PK) — bigint — Foreign key → Shop.shop_pk — NOT NULL
- member_pk (팔로잉멤버PK) — bigInt — Foreign key → Member.member_pk — NOT NULL
- follow_date (팔로우 날짜) — datetime
Shop (가게)
- shop_pk (멤버PK) — bigint — Primary key — NOT NULL
- shop_owner_pk (가게 사장 pk) — bigInt — Foreign key → Member.member_pk — NOT NULL
- shop_name (가게 이름) — varchar(30)
- shop_type (가게 종류) — varchar(15)
- shop_tax_id (가게 사업자 등록번호) — varchar(10)
- shop_created_at (가게 시작일) — date
- shop_info (가게 설명) — text
auction (경매)
- auction_pk (경매pk) — bigint — Primary key — NOT NULL
- auction_owner_pk (등록자pk) — bigInt — Foreign key → Member.member_pk — NOT NULL
- auction_custom_pk (구매자pk) — bigInt — Foreign key → Member.member_pk — NOT NULL
- auction_status (경매상태) — varchar(9)
- auction_title (경매 제목) — varchar(42)
- auction_object_name (경매 품목) — varchar(42)
- auction_start (경매시작) — datetime
- auction_end (경매종료) — datetime
- auction_type (경태종류) — varchar(9)
auction_bid (경매 입찰)
- auction_bid_pk (경매 입찰 pk) — bigint — Primary key — NOT NULL
- auction_pk (경매품목pk) — bigint — Foreign key → auction.auction_pk — NOT NULL
- auction_member_pk (경매입찰자pk) — bigint — Foreign key → Member.member_pk — NOT NULL
- auction_bid_price (경매 입찰 가격) — int
- auction_bid_datetime (경매 입찰 시간) — datetime
auction_history (경매 거래 내역)
- history_pk (거래내역 pk) — bigint — Primary key — NOT NULL
- member_pk (판매자PK) — bigInt — Foreign key → Member.member_pk — NOT NULL
- member_pk (구매자PK) — bigInt — Foreign key → Member.member_pk — NOT NULL
- auction_pk (경매pk) — bigint — Foreign key → auction.auction_pk — NOT NULL
- history_datetime (거래일시) — datetime
discount (할인)
- discount_pk (할인pk) — bigint — Primary key — NOT NULL
- discount_object (할인품목) — varchar(15)
- Field