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