haeng-dong

Tables (6)

ACTION (행동)

  • action_id (액션id) — Bigint — Primary key — NOT NULL
  • sequence (순서) — Bigint
  • event_id (행사id) — Bigint — Foreign key → EVENT.event_id — NOT NULL

BILL_ACTION (지출)

  • bill_action_id (지출id) — Bigint — Primary key — NOT NULL
  • title (지출내역) — Varchar(30)
  • price (지출금액) — Bigint
  • action_id (액션id) — Bigint — Foreign key → ACTION.action_id — NOT NULL

BillActionDetail (지출상세정보)

  • bill_action_detail_id (지출상세정보id) — Bigint — Primary key — NOT NULL
  • member_name (참여자 이름) — Varchar(20)
  • price (가격) — Bigint
  • bill_action_id (지출id) — Bigint — Foreign key → BILL_ACTION.bill_action_id — NOT NULL

EVENT (행사)

  • event_id (행사id) — Bigint — Primary key — NOT NULL
  • name (행사이름) — VarChar(20)
  • token (행사 토큰) — VarChar(255)

EVENT_STEP (차수)

  • event_step_id (차수id) — Bigint — Primary key — NOT NULL
  • name (차수이름) — Varchar(30)
  • sequence (차수순서) — Bigint
  • event_id (행사id) — Bigint — Foreign key → EVENT.event_id — NOT NULL

MEMBER_ACTION (참여자)

  • member_action_id (참여자id) — Bigint — Primary key — NOT NULL
  • member_name (참여자이름) — Varchar(20)
  • status (상태) — Varchar(10)
  • member_group_id (참여자그룹id) — Bigint
  • action_id (액션id) — Bigint — Foreign key → ACTION.action_id — NOT NULL