shop
Tables (11)
ADDRESS
- id — bigint — Primary key
- name — varchar(255)
- zip_code — varchar(255)
- address — varchar(255)
- id (id2) — varchar(255) — Foreign key → USER.id
ITEM
- id — bigint — Foreign key → RAFFLE.item_id
- name — varchar(255)
- description — varchar(255)
- original_price — double
ORDER
- id — varchar(255) — Primary key
- order_type — varchar(255)
- order_status — varchar(255)
- address — varchar(255)
- payment_dudate — date
- payment_id — varchar(255)
ORDER_LINE
- id — bigint
- item_id — long — Foreign key → ITEM.id
ORDER_STOCK
- id — bigint
- stock_id — bigint
- order_quantity — bigint
- order_line_id — bigint — Foreign key → ORDER_LINE.id
- id (id2) — varchar(255) — Foreign key
- id (id3) — varchar(255) — Foreign key
- id (id22) — varchar(255) — Foreign key
- id (id32) — varchar(255) — Foreign key
PARTICIPANT
- id — bigint — Primary key
- id (id2) — varchar(255) — Foreign key → USER.id
- raffle_id — bigint — Foreign key → RAFFLE.id
- stock_id — bigint — Foreign key → STOCK.id
- order_count — bigint
- login_count — bigint
PAYMENT
- id — varchar(255) — Primary key
- amount — double
- payment_id — varchar(255) — Foreign key → ORDER.payment_id
RAFFLE
- id — bigint
- item_id — bigint
- raffle_price — double
- start_date — date
- raffle_end_date — date
- draw_date — date
- payment_due_date — date
STOCK
- id — bigint
- option_name — bigint
- quantity — bigint
- add_price — double
- item_id — bigint — Foreign key → ITEM.id
TIME_DEAL
- id — bigint
- item_id — bigint
- time_deal_price — double
- deal_start_date — date
- deal_end_date — date
USER
- id — varchar(255) — Primary key
- email — varchar(255)
- password — varchar(255)
- nickname — varchar(255)
- role — varchar(255)