123
Tables (11)
ADDRESS
- id — bigint
- name — varchar(255)
- zip_code — varchar(255)
- address — varchar(255)
- user_id — varchar(255)
ITEM
- id — bigint — Primary key — NOT NULL
- name — varchar(255)
- description — varchar(255)
- original_price — double
ORDER
- id — varchar(255) — Primary key — NOT NULL
- order_type — varchar(255)
- order_status — varchar(255)
- user_id — varchar(255)
- address — varchar(255)
- payment_dudate — date
- payment_id — varchar(255)
ORDER_LINE
- id — bigint
- order_id — varchar(255)
- item_id — bigint
ORDER_STOCK
- id — bigint
- stock_id — bigint
- order_quantity — bigint
- order_line_id — bigint
PARTICIPANT
- id — bigint
- raffle_id — bigint
- stock_id — bigint
- user_id — varchar(255)
- order_count — bigint
- login_count — bigint
PAYMENT
- id — varchar(255) — Primary key — NOT NULL
- amount — double
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
TIME_DEAL
- id — bigint
- item_id — bigint — NOT NULL
- time_deal_price — double
- deal_start_date — date
- deal_end_date — date
USER
- id — varchar(255) — Primary key — NOT NULL
- email — varchar(255)
- password — varchar(255)
- nickname — varchar(255)
- role — varchar(255)