took

Tables (3)

account

  • account_seq — bigint — Primary key — NOT NULL
  • main — bit(1)
  • bank_seq — bigint — NOT NULL
  • user_seq — bigint
  • account_name — varchar(255)
  • easy_pwd — varchar(255) — NOT NULL

bank

  • bank_seq — bigint — Primary key — NOT NULL
  • account_pwd — int
  • bank_num — int
  • is_bank — bit(1)
  • balance — bigint
  • account_num — varchar(255)
  • own — varchar(255)

user

  • user_seq — bigint — Primary key — NOT NULL
  • alarm — bit(1) — NOT NULL
  • image_no — int — NOT NULL
  • lat — double
  • lon — double
  • simple_password — int
  • created_at — datetime(6) — NOT NULL
  • role — varchar(10) — NOT NULL
  • birth — varchar(20) — NOT NULL
  • phone_number — varchar(20)
  • user_id — varchar(30)
  • user_name — varchar(30)
  • addr — varchar(100)
  • email — varchar(255) — NOT NULL
  • nickname — varchar(255)
  • password — varchar(255) — NOT NULL
  • gender — enum('F','M')
  • login_status — enum('GOOGLE','KAKAO','TOOK') — NOT NULL