메가폴

테이블 (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