UMC_1st

Tables (11)

Copy Of Copy Of Copy Of member (food)

  • 고유id (id) — int — Primary key — NOT NULL
  • Field2 (food) — varchar(50)

Copy Of Copy Of Untitled (event_alarm)

  • Key (id) — int — Foreign key → Untitled.Key — NOT NULL
  • 고유id (alarm_id) — int — Foreign key → Untitled.고유id — NOT NULL
  • Field (title) — string
  • Field (body) — string

Copy Of Copy Of member (food_prefer)

  • 고유id (id) — int — Primary key — NOT NULL
  • 고유id (user_id) — varchar(50) — Foreign key → member.고유id — NOT NULL
  • 고유id (food_id) — varchar(50) — Foreign key → Copy Of Copy Of Copy Of member.고유id — NOT NULL

Copy Of Copy Of member2 (restaurant)

  • 고유id (id) — int — Primary key — NOT NULL
  • 고유id (food_id) — int — Foreign key → Copy Of Copy Of Copy Of member.고유id — NOT NULL
  • Field2 (rated) — int
  • Field3 (call_num) — int
  • Field4 (address) — varchar(50)
  • Field5 (status) — boolean

Copy Of Copy Of member3 (mission)

  • 고유id (id) — int — Primary key — NOT NULL
  • 고유id (restaurant_id) — int — Foreign key → Copy Of Copy Of member2.고유id — NOT NULL
  • 고유id (food_id) — int — Foreign key → Copy Of Copy Of member2.고유id — NOT NULL
  • Field2 (status) — varchar(50)
  • Field3 (point) — int
  • Field4 (deadline) — datetime
  • Field5 (content) — string

Copy Of Untitled (review_alarm)

  • Key (id) — int — Foreign key → Untitled.Key — NOT NULL
  • 고유id (alarm_id) — int — Foreign key → Untitled.고유id — NOT NULL
  • Field (title) — string
  • Field2 (body) — string

Copy Of member (mission_status)

  • 고유id (id) — int — Primary key — NOT NULL
  • 고유id (mission_id) — int — Foreign key → Copy Of Copy Of member3.고유id — NOT NULL
  • 고유id (restaurant_id) — int — Foreign key → Copy Of Copy Of member3.고유id — NOT NULL
  • 고유id (food_id) — int — Foreign key → Copy Of Copy Of member3.고유id — NOT NULL
  • 고유id (user_id) — int — Foreign key → member.고유id — NOT NULL
  • Field2 (status) — varchar(50)

Untitled (review)

  • Key (id) — int — Primary key — NOT NULL
  • 고유id (user_id) — int — Foreign key → member.고유id — NOT NULL
  • 고유id (restaurant_id) — int — Foreign key → Copy Of Copy Of member2.고유id — NOT NULL
  • 고유id (food_id) — int — Foreign key → Copy Of Copy Of member2.고유id — NOT NULL
  • Field (content) — string
  • Field2 (rated) — int
  • Field3 (photo) — string

Untitled (alarm)

  • Key (id) — int — Primary key — NOT NULL
  • 고유id (user_id) — int — Foreign key → member.고유id — NOT NULL
  • Field

Untitled (qna_alarm)

  • Key (id) — int — Foreign key → Untitled.Key — NOT NULL
  • 고유id (alarm_id) — int — Foreign key → Untitled.고유id — NOT NULL
  • Field (title) — string
  • Field (body) — string

member

  • 고유id (id) — int — Primary key — NOT NULL
  • Field2 (password) — varchar(50)
  • Field3 (email) — varchar(50)
  • Field4 (name) — varchar(10)
  • Field5 (nickname) — varchar(10)
  • Field6 (gender) — varchar(10)
  • Field7 (point) — int
  • Field8 (birth_date) — datetime
  • Field (address) — varchar(50)
  • Field2 (event_alarm) — boolean
  • Field3 (qna_alarm) — boolean
  • Field4 (review_alarm) — boolean
  • Field5 (status) — varchar(15)
  • Field6 (created_at) — datetime(6)
  • Field7 (updated_at) — datetime(6)
  • Field (inactive_date) — datetime
  • Field2 (location_allow) — boolean
  • Field3 (marketing_allow) — boolean