main
Tables (13)
BOARD
- id (BOARD_ID) — not null — Primary key — NOT NULL
- member_id (MEMBER_ID) — not null — Foreign key → MEMBER.id
- created_at (CREATED_AT) — not null
- modified_at (MODIFIED_AT) — not null
- content (CONTENT) — not null
- board_image_url (IMAGE_URL)
- board_title (Field) — not null
- board_content (Field2) — not null
COMMENT_BOARD
- id (Key) — not null — Primary key — NOT NULL
- board_id (BOARD_ID) — not null — Foreign key → BOARD.id — NOT NULL
- member_id (Field) — not null
- comment_content (Field2) — not null
- created_at (Field3) — not null
- modified_at (Field4)
COMMENT_DRINKS
- id (Key2) — not null — Primary key — NOT NULL
- drink_id (Key) — not null — Foreign key → DRINK.id — NOT NULL
- member_id (Field) — not null
- comment_content (Field2) — not null,
- created_at (Field3) — not null
- modified_at (Field4)
DRINK (DRINKS)
- id (Key) — not null — Primary key — NOT NULL
- drinks_name (Field) — not null
- drinks_code (Field2) — not null, identity
- drinks_abv (Field4) — not null
- tasting_note (Field3) — not null
- drinks_image_url (Field5) — not null
- drinks_price_rank (Field6) — not null
- drinks_volume (Field7) — not null
IMAGE (Untitled4)
- id (Key) — not null — Primary key — NOT NULL
- board_id (BOARD_ID) — not null — Foreign key → BOARD.id — NOT NULL
- file_name (Field) — not null
- img_url (Field2) — not null,
LIKE_BOARD
- id (LIKE_BOARD_ID) — not null — Primary key — NOT NULL
- board_id (BOARD_ID) — not null — Foreign key → BOARD.id — NOT NULL
- member_id (MEMBER_ID) — not null — Foreign key → BOARD.member_id
LIKE_DRINKS
- id (Key2) — not null — Primary key — NOT NULL
- drink_id (Key) — not null — Foreign key → DRINK.id — NOT NULL
- member_id (Field) — not null
MEMBER
- id (MEMBER_ID) — not null — Primary key
- email (VARCHAR) — not null, identity
- display_name (DISPLAY_NAME) — not null
- phone_number (PHONE_NUMBER)
- about_me (ABOUT_ME)
- profile_picture_url (PROFILE_PICTURE)
- oauth_type (Field) — not null
SNACK
- id (Key) — not null — Primary key — NOT NULL
- snack_kcal (Field)
- snack_info (Field2)
- snack_image_url (Field3)
- snack_name (Field4) — not null, identity
SNACK_DRINKS (Untitled3)
- id (Key3) — not null — Primary key — NOT NULL
- drink_id (Key) — not null — Foreign key → DRINK.id — NOT NULL
- snack_id (Key2) — not null — Foreign key → SNACK.id — NOT NULL
TAG
- id (Key) — not null — Primary key — NOT NULL
- tag_name (Field) — not null, identity
- tag_info (Field2) — not null
TAG_BOARD (Untitled2)
- id (Key2) — not null — Primary key — NOT NULL
- tag_id (Key) — not null — Foreign key → TAG.id — NOT NULL
- board_id (BOARD_ID) — not null — Foreign key → BOARD.id — NOT NULL
TAG_DRINKS (Untitled)
- id (Key3) — not null — Primary key — NOT NULL
- tag_id (Key) — not null — Foreign key → TAG.id — NOT NULL
- drink_id (Key2) — not null — Foreign key → DRINK.id — NOT NULL