Spring

Tables (10)

Copy Of Untitled (SHOP)

  • Key (SHOP_ID) — VARCHAR(30) — Primary key — NOT NULL
  • Field (SHOP_LOCATION) — VARCHAR(30)
  • Field2 (SHOP_INFO) — VARCHAR(100)
  • Field (CREATED_TIME) — DATETIME(6)
  • Field (UPDATED_TIME) — DATETIME(6)

Untitled (FOOD)

  • Key (FOOD_NAME) — VARCHAR(30) — Primary key — NOT NULL
  • Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled3.Key
  • Field (CREATED_TIME) — DATETIME(6)
  • Field2 (UPDATED_TIME) — DATETIME(6)

Untitled (MISSION)

  • Key (mission_Id) — int — Primary key — NOT NULL
  • Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled3.Key
  • Field (mission_name) — VARCHAR(40)
  • Field (content) — int
  • Field (mission_point) — int
  • Field (status) — ENUM('진행중','진행완료')
  • Field (Created_time) — DATETIME(6)
  • Field2 (FINISED_TIME) — DATETIME(6)
  • Key (SHOP_ID) — VARCHAR(30) — Foreign key → Copy Of Untitled.Key — NOT NULL

Untitled (MAP)

  • Key (map_id) — VARCHAR(20) — Primary key — NOT NULL
  • Key (SHOP_ID) — VARCHAR(30) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field2 (shop_info) — VARCHAR(50)

Untitled (alram)

  • Key (alram_id) — int — Primary key — NOT NULL
  • Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled3.Key

Untitled (mission_notice)

  • Key (id) — int — Primary key — NOT NULL
  • Key (alram_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (review) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (mission_Id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled.Key
  • Field (content) — text

Untitled (review)

  • Key (review) — int — Primary key — NOT NULL
  • Key (mission_Id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled.Key
  • Field (content) — text
  • Field (CREATED_TIME) — DATETIME(6)
  • Field2 (UPDATED_TIME) — DATETIME(6)
  • Field (RATING) — int

Untitled (Comment)

  • Key (comment_id) — LONG — Primary key — NOT NULL
  • Key (review) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (MEMBER_ID) — VARCHAR(20) — Foreign key → Untitled3.Key
  • Field (길이) — LONG
  • Field (Content) — VARCHAR(100)
  • Field (CREATED_TIME) — DATETIME(6)
  • Field2 (UPDATED_TIME) — DATETIME(6)

Untitled

    Untitled3 (MEMBER)

    • Key (MEMBER_ID) — VARCHAR(20) — Primary key
    • Field (NICK_NAME) — TEXT
    • Field (PHONE_NUM) — int
    • Field2 (EMAIL) — VARCHAR(50)
    • Field (PASSWORD) — VARCHAR(50)
    • Field2 (GENDER) — ENUM('남','여')
    • Field3 (BIRTH) — VARCHAR(6)
    • Field (ADDRESS) — VARCHAR(100)
    • Field (status) — varchar(15)
    • Field (inactive_time) — DATETIME(6)
    • Field (CREATED_TIME) — DATETIME(6)
    • Field (UPDATED_TIME) — DATETIME(6)