Project_Neouri

Tables (10)

Alert (신고/문의)

  • user_id (user id) — not null
  • type1 (check type1) — check(type1 in ('A', 'Q')) not null
  • title (alert title) — not null
  • context (alert context) — not null

Category (관심사)

  • category_seq (category sequence) — primary key — Primary key — NOT NULL
  • type — not null

Category_seq (Category Sequence)

  • category_seq (sequence)

Event (이벤트)

  • event_seq (event sequence) — primary key — Primary key — NOT NULL
  • start_date (start timestamp) — not null
  • end_date (end timestamp) — not null
  • event_title (event title) — not null
  • event_context (event context) — not null
  • category_seq1 (category1) — not null
  • category_seq2 (category2)
  • category_seq3 (category3)

Event_seq (Event Sequence)

  • event_seq (sequence)

Map (좌표)

  • latitude
  • longitude

Promise (약속)

  • prom_seq (promise sequence) — primary key — Primary key — NOT NULL
  • prom_category (category) — not null
  • prom_latitude (latitude) — not null
  • prom_longitude (longitude) — not null
  • start_time (start timestamp) — not null
  • end_time (end timestamp) — not null
  • start_age (start age) — not null
  • end_age (end age) — not null
  • prom_gender (gender) — check(prom_gender in ('M', 'F', 'E'))
  • person_num (person count) — not null
  • prom_place1 (place latitude) — not null
  • prom_place2 (place longitude) — not null
  • prom_context (promise context)
  • event_seq (event sequence)

Promise_seq (Promise Sequence)

  • prom_seq (sequence)

User (이용자)

  • user_id (id) — primary key — Primary key — NOT NULL
  • user_seq (sequence) — not null
  • user_pw (password) — not null
  • uwer_name (name) — not null
  • user_age (age) — not null
  • user_gender (gender) — check(user_gender in('M', 'F')) not null
  • user_address1 (latitude) — not null
  • user_address2 (longitude) — not null
  • user_category1 (category1) — 관심사 3개까지 설정하지 않아도 됩니다
  • user_category2 (category2) — 관심사 3개까지 설정하지 않아도 됩니다
  • user_category3 (category3) — 관심사 3개까지 설정하지 않아도 됩니다
  • user_class (class) — check(user_class in('normal', 'black', 'admin')) not null
  • late — not null
  • absent — not null
  • no_manners (no manners) — not null

User_seq (User Sequence)

  • user_seq (sequence)