메가폴
테이블 (24)
Address (Untitled)
- address_id (Key) — bigint — 기본 키 — NOT NULL
- address (Field) — varchar
- create_time (Field2) — timestamp
- modified_time (Field3) — timestamp
- status (Field4) — varchar
- member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
Comment (댓글)
- comment_id (Key) — bigint — 기본 키 — NOT NULL
- comment_id (Key2) — bigint — 외래 키 → Comment.comment_id — NOT NULL
- topicId (Key3) — bigint — 외래 키 → Topic.topicId — NOT NULL
- member_id (Key4) — bigint — 외래 키 → Member.member_id — NOT NULL
- content (Field) — varchar
- create_time (Field2) — timestamp
- modified_time (Field3) — timestamp
DibsTopic (찜한 토픽)
- dibs_topic_id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
- topicId (Key3) — bigint — 외래 키 → Topic.topicId — NOT NULL
DirectPurchaseProduct (바로 구매 상품)
- product_id (Key) — bigint — 외래 키 → Product.product_id — NOT NULL
- quantity (Field) — int
- sale_quantity (Field8) — int
- end_time (Field5) — timestamp
- product_type (Field7) — varchar
- status (Field9) — varchar
- pickup_method (Field10) — varchar
LotteryMegaCashItem (확률형 메가캐시 아이템)
- mega_cash_item_id (Key) — bigint — 외래 키 → MegaCashItem.mega_cash_item_id — NOT NULL
- pay_mega_cash (Field) — int
- Field2
LotteryProduct (응모형 상품)
- product_id (Key) — bigint — 외래 키 → Product.product_id — NOT NULL
- winning_quantity (Field5) — int
- lottery_try_count (Field6) — int
- end_time (Field7) — timestamp
- pickup_method (Field8) — varchar
MainBanner (메인 배너)
- main_banner_id (Key) — bigint — 기본 키 — NOT NULL
- topicId (Key2) — bigint — 외래 키 → Topic.topicId — NOT NULL
- section (Field) — varchar
MegaCash (메가캐시)
- mega_cash_id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Field) — bigint
- mega_cash_id (Field7) — int
- status (Field4) — varchar
- use_entity (Field5) — varchar
- use_id (Field6) — bigint
MegaCashItem (메가캐시 아이템)
- mega_cash_item_id (Key) — bigint — 기본 키 — NOT NULL
- type (Field) — varchar
- name (Field2) — varchar
- price (Field3) — int
- description (Field4) — varchar
- status (Field5) — varchar
- item_type (Field6) — varchar
- is_show (Field7) — boolean
Member (회원)
- member_id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — NOT NULL
- member_type (Field) — varchar
- email (Field2) — varchar
- nickname (Field3) — varchar
- member_status (Field4) — varchar
- phone_number (Field5) — varchar
- create_time (Field9) — timestamp
- modified_time (Field10) — timestamp
- delete_at (Field11) — timestamp
- ci (Field12) — varchar
- total_monthly_payment_cash (Field13) — int
- current_address (Field14) — varchar
- serviceAgree (Field15) — boolean
- personalInfoAgree (Field16) — boolean
- fourteenAgeOver (Field17) — boolean
NormalMegaCashItem (일반 메가캐시 아이템)
- mega_cash_item_id (Key) — bigint — 외래 키 → MegaCashItem.mega_cash_item_id — NOT NULL
- pay_mega_cash (Field) — int
- Field2
Product (상품)
- product_id (Key) — bigint — 기본 키 — NOT NULL
- product_name (Field) — varchar
- thumnail (Field2) — varchar
- price (Field3) — int
- cash_type (Field4) — varchar
- product_type (Field5) — varchar
ProductOrder (상품 주문)
- mega_cash_item_order (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
- product_id (Key3) — bigint — 외래 키 → Product.product_id — NOT NULL
- create_time (Field) — timestamp
- update_time (Field2) — timestamp
- pickup_method (Field3) — varchar
- address (Field4) — varchar
ProposalTopic (제안 토픽)
- proposal_topic_id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
- title (Field) — varchar
- category (Field2) — varchar
- thumnails (Field3) — varchar
- description (Field4) — varchar
- choice_type (Field5) — varchar
- proposal_status (Field6) — varchar
- created_by (Field7) — varchar
- updated_by (Field8) — varchar
- create_time (Field9) — timestamp
- modfied_time (Field10) — timestamp
ProposalTopicDetail (제안 토픽 상세)
- topicDetailId (Key) — bigint — 기본 키 — NOT NULL
- proposal_topic_id (Key2) — bigint — 외래 키 → ProposalTopic.proposal_topic_id — NOT NULL
- option (Field) — varchar
- fluidity (Field2) — bigint
- participant_count (Field3) — bigint
ProposalTopicTag (제안 토픽 태그)
- proposalTopicCategoryId (Key) — bigint — 기본 키 — NOT NULL
- proposal_topic_id (Key3) — bigint — 외래 키 → ProposalTopic.proposal_topic_id — NOT NULL
- tag (Field) — varchar
Topic (토픽)
- topicId (Key) — bigint — 기본 키 — NOT NULL
- proposal_topic_id (Key2) — bigint — 외래 키 → ProposalTopic.proposal_topic_id — NOT NULL
- title (Field) — varchar
- category (Field2) — varchar
- thumnails (Field3) — varchar
- description (Field4) — varchar
- choice_type (Field5) — varchar
- created_by (Field6) — varchar
- updated_by (Field7) — varchar
- create_time (Field8) — timestamp
- modfied_time (Field9) — timestamp
- is_show (Field10) — boolean
- topic_status (Field11) — varchar
- dibs_count (Field12) — bigint
- reply_count (Field13) — bigint
- participant_count (Field14) — bigint
- start_time (Field15) — timestamp
- end_time (Field16) — timestamp
TopicOption (토픽 선택지)
- topic_option_id (Key) — bigint — 기본 키 — NOT NULL
- topic_id (Key2) — bigint — 외래 키 → Topic.topicId — NOT NULL
- option (Field) — varchar
- fluidity (Field2) — bigint
- participant_count (Field3) — bigint
TopicTag (토픽 태그)
- topicCategoryId (Key) — bigint — 기본 키 — NOT NULL
- topicId (Key2) — bigint — 외래 키 → Topic.topicId — NOT NULL
- tag (Field) — varchar
WalletMegaCashItem (메가캐시 충전상품 결제)
- wallet_mega_cash_item_id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
- mega_cash_item_id (Key3) — bigint — 외래 키 → MegaCashItem.mega_cash_item_id — NOT NULL
- total_price (Field) — bigint
- create_time (Field2) — timestamp
- modified_time (Field3) — timestamp
WalletMegaCashItemHistory (충전 금액 히스토리)
- wallet_mega_cash_history_id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → Member.member_id — NOT NULL
- wallet_cash (Field) — bigint
- create_time (Field3) — timestamp
- modfied_time (Field2) — timestamp
- before_monthly_payment_cash (Field4) — bigint
- ci (Field5) — varchar
hasTopic (Untitled3)
- has_topic (Key) — bigint — 기본 키 — NOT NULL
- topic_option_id (Field)
- member_id (Field2)
- quantity (Field3)
- Field4
hasTopicHistory (Untitled4)
기프티콘 (Untitled2)
- gifticon_id (Key) — 기본 키 — NOT NULL
- Field
- direct_purchase_product_id (Key2) — bigint — 외래 키 → DirectPurchaseProduct.product_id — NOT NULL